Computer Class-11 (HSSC-I)
SLO-Based 195 MCQs Quiz Worksheet for Practice
of all Chapters with the Answers Key
According to New Syllabus for 2023-2024 Exams and onward
As Prescribed by
Federal Board of Intermediate and Secondary Education,
Islamabad and All other Examination Board in Pakistan
BY
MUHAMMAD JUNAID KHATTAK
M/Sc. PHYSICS, B.Sc, COMPUTER SCIENCE
PESHAWAR UNIVERSITY
Click on the Chapter-wise MCQs Quiz for Practice: or Scroll below
Chapter No. 1: Overview of Computer System (20 MCQs)
Chapter No. 2: Computer Memory (20 MCQs)
Chapter No. 3: Central Processing Unit (20 MCQs)
Chapter No. 4: Inside System Unit (20 MCQs)
Chapter No. 5: Network Communication and Protocols (40 MCQs)
Chapter No. 6: Wireless Communication (20 MCQs)
Chapter No. 7: Database Fundamental (35 MCQs)
Chapter No. 8: Database Development (20 MCQs)
*********************************
Chapter No. 1: Overview of Computer Systems
MCQs Practice Quiz
1. Which of the following is the smallest computer?
(a) Main frame (b) Minicomputer
(c) Microcomputer (d) Supercomputer
Answer is __________________________
2. How many instructions per second a mini-computer can execute
(a) thousands of computers (b) millions of instructions
(c) Billions of instruction (d) above trillion instructions
Answer is __________________________
3. What type of software is MS Word?
(A) system software (b) application software
(c) utility software (d) language processor
Answer is __________________________
4. Which device is most suitable for playing games?
(a) mouse (b) keyboard
(c) joystick (d) light pen
Answer is __________________________
5. CPU is an example of _____
(a) Software (b) Firmware
(c) Hardware (d) Control Unit
Answer is __________________________
6. Software can be classified in ______ categories.
(a) 2 (b) 3
(c) 4 (d) 5
Answer is __________________________
7. Which key deletes a character to the left of the cursor?
(a) Backspace (b) Delete
(c) Esc (d) Tab
Answer is __________________________
8. Which printer works like a photocopier machine?
(a) Inkjet (b) Laser
(c) Thermal (d) Drum
Answer is __________________________
9. Which of the following is an impact printer.
(a) dot matrix printer (b) laser printer
(c) inkjet printer (d) plotter
Answer is __________________________
10. ___software controls the operation of a hardware device.
(a) utility software (b) language processor
(c) application software (d) device driver
Answer is __________________________
11. Which of the following devices is used to print large-size hardcopy.
(a) plotter (b)inkjet printer
(c) laser printer (d)chain printer
Answer is __________________________
12. Which of the following devices converts spoken words into electrical form.
(a)touchpad (b)microphone
(c)scanner (d)digital camera
Answer is __________________________
13. __________software converts computer programs to machine language.
(a) utility program (b) device driver
(c) language processor (d) application software
Answer is __________________________
14. __________ is a special-purpose computer.
(a) Analogue (b) Digital
(c) Hybrid (d) both a and c
Answer is __________________________
15. QWERTY is used with reference to:
(a) screen layout (b) mouse button layout
(c) keyboard layout (d) word processing software
Answer is __________________________
16. Hardware is best described as:
(a) Physical Parts (b) Logical Parts
(c) Printed Copy (d) A Program
Answer is __________________________
17. MICR stands for
(a) Magic In Character Reading (b) Magic Ink Character Recorder
(c) Magic Ink Character Reader (d) None of the Above
Answer is __________________________
18. Which of the following is not an input device?
(a) Mouse (b) Joystick
(c) Printer (d) Microphone
Answer is __________________________
19. There are ___ Function Keys on a keyboard
(a) 4 (b) 8
(c) 12 (d) 16
Answer is __________________________
20. Which of the following is productivity software?
(a) Spreadsheet software (b) Utility software
(c) Windows 7 (d) compiler
Answer is __________________________
Answer Key of Chapter No. 1: Overview of Computer System
1 | ( c ) | 2 | ( c ) | 3 | ( b ) | 4 | ( c ) | 5 | ( c ) |
6 | ( a ) | 7 | ( a ) | 8 | ( b ) | 9 | ( a ) | 10 | ( d ) |
11 | ( a ) | 12 | ( b ) | 13 | ( c ) | 14 | ( d ) | 15 | ( c ) |
16 | ( a ) | 17 | ( d ) | 18 | ( c ) | 19 | ( c ) | 20 | ( a ) |
*********************************
Chapter No. 2: Computer Memory
MCQs Practice Quiz Worksheet
1. Which of the following is the fastest memory?
(a) RAM (b) ROM
(c) cache memory (d)USB flash memory
Answer is __________________________
2 How much is 1MB memory equal to?
(a) 1024 bytes (b) 1024 TB
(c) 1024 kB (d) 1024 GB
Answer is __________________________
3. Which of the following is volatile memory?.
(a) RAM (b) ROM
(c)PROM (d) EEPROM
Answer is __________________________
4. Which of the following has the highest storage capacity
(a) DVD (b) Blu-ray disk
(c) CD (d) floppy disk
Answer is __________________________
5. USB flash device is what type of memory?
(a) Magnetic memory (b) Optical memory
(c) Electronic memory (d) Primary memory
Answer is __________________________
6. Which of the following memory devices has the smallest storage capacity?
(a) cache memory (b)RAM
(c)CD (d) Memory card
Answer is __________________________
7. Which of the following storage devices is obsolete nowadays?.
(a) Hard disk (b) CD
(c) Memory card (d) Floppy disk
Answer is __________________________
8. Which memory communicates directly with the CPU?
(a) Main memory (b) Secondary memory
(c) Hard disk (d) USB flash drive
Answer is __________________________
9. Which of the following memory devices has sequential access to data?
(a) Magnetic disk (b) Optical memory
(c) Magnetic tape (d) Chip memory
Answer is __________________________
10. Where are the registers located?
(a) Inside hard disk (b) Inside DVD
(c) Inside RAM (d) inside microprocessor
Answer is __________________________
11. The smallest unit of memory is______
(a) Bit (b) Byte
(c) KB (d) MB
Answer is __________________________
12. The basic unit of computer memory is_______
(a) Bit (b) Byte
(c) KB (d) MB
Answer is __________________________
13. The RAM is also called_______
(a) Random Access Memory (b) Primary Memory
(c) Main Memory (d) All of these
Answer is __________________________
14. Data is temporarily stored in_______
(a) CPU (b) Secondary Memory
(c) Main Memory (d) None of these
Answer is __________________________
15. In_____ instructions are stored at the time of manufacturing.
(a) RAM (b) ROM
(c) Cache (d) Registers
Answer is __________________________
16._____ is the fastest memory
(a) RAM (b)ROM
(c) Cache (d) Registers
Answer is __________________________
17. A single character can be stored in a_____
(a) Bit (b)Byte
(c) Word (d) Cell
Answer is __________________________
18. The information contained in ____ is lost when power is off.
(a) RAM (b)ROM
(c) Hard Disk (d) Flesh Memory
Answer is __________________________
19. ____ has the highest capacity.
(a) RAM (b) ROM
(c) Hard Disk (d) CD-ROM
Answer is __________________________
20. The Operating System is stored in ______ when the computer is ON.
(a) RAM (b) ROM
(c) Hard Disk (d) CD-ROM
Answer is __________________________
Answer Key of Chapter No. 2: Computer Memory
1 | ( c ) | 2 | ( c ) | 3 | ( a ) | 4 | ( b ) | 5 | ( c ) |
6 | ( a ) | 7 | ( d ) | 8 | ( a ) | 9 | ( c ) | 10 | ( d ) |
11 | ( a ) | 12 | ( b ) | 13 | ( d ) | 14 | ( c ) | 15 | ( b ) |
16 | ( d ) | 17 | ( b ) | 18 | ( a ) | 19 | ( c ) | 20 | ( a ) |
*********************************
Chapter No. 3: Central Processing Unit
MCQs Practice Quiz Worksheet
1. Which part of the computer performs the fetch, decode, and execute cycle?
(a)ALU (b) Control Unit
(c) Output unit (d) Register
Answer is __________________________
2. Where are the results of ALU operations transferred?
(a) Counter Register (b) Base Register
(c) Data Register (d) Accumulator Register
Answer is __________________________
3. Which of these buses selects a memory word for a read or write operation?
(a) Data Bus (b) Control Bus
(c) Address Bus (d) System Bus
Answer is __________________________
4. Which of these registers controls the sequence in which instructions are fetched from memory for execution?
(a)Program Counter (b) Memory Buffer Register
(c) Data register (d) Counter Register
Answer is __________________________
5. A memory word that is to be stored in or fetched from memory must first be transferred into which register?
(a) Accumulator (b) Data Register
(c) Memory Buffer Register (d) Program counter
Answer is __________________________
6. Which instruction causes the transfer of instruction execution to the specified address?
(a) Comparison (b) Branch
(c) Shift (d) Data Movement
Answer is __________________________
7. Which of these instructions will perform the addition of two numbers?
(a) Operation (b) Shift
(c)Comparison (d) Data Movement
Answer is __________________________
8. Through which bus, instructions are transferred from the main memory to the instruction register?
(a) Control Bus (b) Address Bus
(c) Instruction Bus (d) Data Bus
Answer is __________________________
9. How many distinct operations can be performed if the op-code of a microprocessor consists of bits?
(a)4 (b) 8
(c) 16 (d) 32
Answer is __________________________
10. Which part of the computer decodes instructions?
(a) ALU (b) Main Memory
(c) Program Counter (d) Control Unit
Answer is __________________________
11. Processor includes all of the following except
(a) ALU (b) RAM
(c) Register (d) Control Unit
Answer is __________________________
12. ____ coordinates the activities of all hardware.
(a) ALU (b) CU
(c) Register (d) Cache
Answer is __________________________
13. ____ holds the data coming from or going to memory.
(a) MAR (b) DAR
(c) DR (d) MBR
Answer is __________________________
14. ____ is not a data transfer instruction.
(a) MOV (b) LD
(c) ADD (d) XCHG
Answer is __________________________
15. Which of the following is an example of zero-address instruction.
(a) STOP (b) LD
(c) JMP (d)XCHG
Answer is __________________________
16. Which of the following processors has a clock speed of 1.7 GHz
(a) P-IV (b) AMD
(c) None (d) Both
Answer is __________________________
17. Intel and AMD are manufacturers of _______
(a) Windows (b) Processor
(c) Motherboards (d) Monitors
Answer is __________________________
18. ___ step reads a new instruction from memory
(a) Fetch (b) Decode
(c) Execute (d) Read
Answer is __________________________
19. What does the data bus carry?
(a) Data (b) Address
(c) Data and instructions (d) Signal
Answer is __________________________
20. A set of bits that tells the computer to perform a specific operation is called_____
(a) Instruction code (b) OP Code
(c) Operand (d) Operation
Answer is __________________________
Answer Key of Chapter No. 3: Central Processing Unit
1 | ( b ) | 2 | ( d ) | 3 | ( c ) | 4 | ( a ) | 5 | ( c ) |
6 | ( b ) | 7 | ( a ) | 8 | ( d ) | 9 | ( c ) | 10 | ( d ) |
11 | ( b ) | 12 | ( b ) | 13 | ( d ) | 14 | ( c ) | 15 | ( a ) |
16 | ( a ) | 17 | ( b ) | 18 | ( a ) | 19 | ( c ) | 20 | ( a ) |
*********************************
Chapter No. 4: Inside System Unit – MCQs
MCQs Practice Quiz
1. Which port is generally used to connect video devices to the computer?
(a) FireWire (b) USB
(c) PS/2 (d) Parallel
Answer is __________________________
2. What is a computer casing with all the components installed inside it called?
(a) Computer System (b) CPU
(c) Motherboard (d) System Unit
Answer is __________________________
3. What is the interface that provides connection to external devices called?
(a) Expansion Slot (b) Memory Slot
(c) Disk Controller (d) Port
Answer is __________________________
4. Which of the following provides an interface to the network?
(a) NIC (b) Modem
(c) Parallel Port (d) BIOS
Answer is __________________________
5. Which part of the computer protects and organizes all the main parts of the computer?
(a) Power Supply (b) Motherboard
(c) Casing (d) Expansion Slots
Answer is __________________________
6. What is the purpose of the power supply in the computer?
(a) to convert low voltage to high voltage (b) to convert DC to AC
(c) to convert AC to low voltage DC (d) to generate power
Answer is __________________________
7. Which circuit board connects all the components of the computer?
(a) Motherboard (b) Ports
(c) Network cards (d) Cables
Answer is __________________________
8. What is BIOS?
(a) Programs in RAM (b) Port
(c) Interface (d) Non-volatile ROM chip
Answer is __________________________
9. Which of these provides the high-speed channel for attaching the video card to the motherboard?
(a) IDE interface (b) AGP
(c) Disk Controller (d) Memory Slot
Answer is __________________________
10. Which card displays text, graphics, and images on the screen?
(a) Network Card (b) Gigabit Card
(c) Modem Card (d) Video graphics card
Answer is __________________________
11. ____________ of computer converts AC voltage to DC voltage
(a) Power supply (b) Graphics adopter
(c) Motherboard (d) AToD Converter
Answer is __________________________
12. ____________ saves the processor from overheating.
(a) Fan (b) Cooling system
(c) Motherboard (d) Cooling foil
Answer is __________________________
13. ____________is the rectangular-shaped port that connects video devices to computers.
(a) VGA (b) HDMI
(c) Firewire (d) AGP
Answer is __________________________
14. ____ transmits Audio-Video data in totally digital form via a single cable.
(a) VGA (b) HDMI
(c) FireWire (d) Serial Port
Answer is __________________________
15. Dial-up Modems can transmit up to ____________
(a) 56KBPS (b) 128 KBPS
(c) 1MBPS (d) More than 1 MBPS
Answer is __________________________
16. ISDN Modems can transmit up to ____________
(a) 56KBPS (b) 128 KBPS
(c) 1MBPS (d) More than 1 MBPS
Answer is __________________________
17. NIC is also known as
(a) Noise Interruption Card (b) Modem
(c) LAN Card (d) DSL
Answer is __________________________
18. ____________ can read or write 4 words of data per clock cycle.
(a) DDR-1 (b) DDR-2
(c) DDR-3 (d) DDR-4
Answer is __________________________
19. ____________ interfaces can provide communication at the rate of 3GB/sec.
(a) IDE (b) SATA-1
(c) SATA-2 (d) SATA-3
Answer is __________________________
20. System unit contains ____________ main components.
(a) 2 (b) 4
(c) 8 (d) 16
Answer is __________________________
Answer Key of Chapter No. 4: Inside System Unit
1 | ( a ) | 2 | ( d ) | 3 | ( d ) | 4 | ( a ) | 5 | ( c ) |
6 | ( c ) | 7 | ( a ) | 8 | ( d ) | 9 | ( b ) | 10 | ( d ) |
11 | ( a ) | 12 | ( b ) | 13 | ( c ) | 14 | ( b ) | 15 | ( a ) |
16 | ( b ) | 17 | ( c ) | 18 | ( b ) | 19 | ( c ) | 20 | ( a ) |
*********************************
Chapter No. 5: Network Communication and Protocols
MCQs Practice Quiz
1. In which communication mode data can be sent and received in both directions but not simultaneously?
(a) Simplex mode (b) Half duplex mode
(c) Full duplex mode (d) Synchronous transmission
Answer is __________________________
2. Which of the following network devices connects a network to another that uses a different protocol?
(a)Switch (b) Gateway
(c) Router (d) Modem
Answer is __________________________
3. Which of the following networks provides remote access to individuals and offices to their organization
network?
(a) LAN (b) WAN
(c) MAN (d) VAN
Answer is __________________________
a
4. In which topology a hub (switch) is used?
a) Star topology (b) Ring topology
(c) Bus topology (d) Mesh topology.
Answer is __________________________
a
5. Which topology is most expensive to implement?
(a) Star topology (b) Ring topology
(c) Bus topology (d) Mesh topology
Answer is __________________________
a
6. Which layer of the OSI Model decides which physical pathway the data should take to reach the destination?
(a) Data link layer (b) Network layer
(c) Transport layer (d) Session layer
Answer is __________________________
7. Which network layer performs security, name recognition, logging, and similar functions.
(a)Transport layer (b) Network layer
(c) Presentation Layer (d) Session Layer
Answer is __________________________
8. Which of these cables transmit data using light waves?
(a) Twisted pair cable (b) coaxial cable
(c) Fiber optic cable (d) Telephone line
Answer is __________________________
9. Which of these transmissions uses a star/stop bit?
(a) Asynchronous (b) Synchronous
(c) Half-duplex (d) Full-duplex
Answer is __________________________
10. Which bits are used at the start of a class B IP?
(a) 0 (b) 10
(c) 101 (d) 110
Answer is __________________________
a
11. Computer networks allow users to share.
(a)Hardware (b) Software
(c) Information (d) All
Answer is __________________________
a
12. The set of rules to exchange data in a communication network is called.
(a) Protocol (b) Procedure
(c) Token (d) Token
Answer is __________________________
a
13. All the following are the elements of the data communication system EXCEPT.
(a) Sender (b) Transmission Medium
(c) Receiver (d) Voltage
Answer is __________________________
14. A telephone conversation is an example of
(a)Full-duplex (b) Half-duplex
(c) Simplex (d) Multiplex
Answer is __________________________
15. Television broadcast is an example of
(a) Full-duplex (b) Half-duplex
(c) Simplex (d) Multiplex
Answer is __________________________
16. In which type of data transmission data is transmitted block by block?
(a) Asynchronous (b) Synchronous
(c) Direct (d) Indirect
Answer is __________________________
17. Which of the following is an example of unguided media
(a) Twisted pair (b) co-axial
(c) satellite (d) Fiber optic
Answer is __________________________
a
18. Which type of transmission media uses light waves for transmitting information?
(a) Twisted pair cable (b) Fiber optic cable
(c) Coaxial cable (d) Radio wave
Answer is __________________________
a
19. Many networks include a central computer called.
(a) Server (b) Modem
(c) switch (d) Silent
Answer is __________________________
a
20. A lab with twenty computers and a laser printer is an example of ____________ area network
(a) Limited (b) line
(c) Local (d) Little
Answer is __________________________
21. The physical layout of connected devices in a network is called.
(a) Topology (b) Connecter
(c) Session (d) link
Answer is __________________________
22. Which topology requires a central device such as a switch?
(a) Star (b) Ring
(c) Band (d) bus
Answer is __________________________
23. Which of the following topologies is expensive and difficult to install
(a) Bus (b) Ring
(c) Mesh (d) Star
Answer is __________________________
24. The entire network goes down in which topology if the backbone cable fails?
(a) Bus (b) Ring
(c) Mesh (d) Star
Answer is __________________________
a
25. How many layers does the OSI model consist of?
(a) 7 (b) 3
(c) 6 (d) 4
Answer is __________________________
a
26. Which layer is responsible for establishing, maintaining, and terminating user connection?
(a) Application (b) Presentation
(c) Transport (d) Session
Answer is __________________________
a
27. The topmost layer of the OSI is called ______________.
(a) Application (b) Presentation
(c) Transport (d) session
Answer is __________________________
28. The bottom layer of the OSI model is
(a) Application (b) physical
(c) Presentation (d) Transport
Answer is __________________________
29. Which of the following is the most important layer concerned with transmitting a stream of bits over the physical cables or wires
(a) Application (b) physical
(c) Session (d) Transport
Answer is __________________________
30. The layer that defines the formats the data uses as it is transmitted on the communication line is called ______________.
(a) Application layer (b) Presentation layer
(c) Transport layer (d) Physical layer
Answer is __________________________
31. The layer that provides services that directly support user applications is ______________.
(a) Application layer (b) Presentation layer
(c) Transport layer (d) Physical layer
Answer is __________________________
32. In the OSI model, encryption and decryption are functions of which layer?
(a) Application (b) Presentation
(c) Transport (d) Session
Answer is __________________________
33. OSI stands for
(a) Open system interconnection (b) Open system international
(c) Open smart internet (d) Open system interlink
Answer is __________________________
34. Which network is made of a set of switches connected by a physical link?
(a) Farm switched (b) Circuit switched
(c) Line-switched (d) Datagram switching
Answer is __________________________
35. An IP address is composed of
(a) 4 bits (b) 16 bits
(c) 32 bits (d) 256 bits
Answer is __________________________
36. The four numbers in an IP address are called____________.
(a) Octet (b) Codec
(c) Octal (d) Bytes
Answer is __________________________
37. Which class IP addresses were designed for large networks?
(a) 255.0.0.0 (b) 255.255.0.0
(c) 255.255.255.0 (d) 255.255.255.255
Answer is __________________________
38. The default mask for class A is
(a) A (b) B
(c) C (d) D
Answer is __________________________
39. The default mask for class B is
(a) 255.0.0.0 (b) 255.255.0.0
(c) 255.255.255.0 (d) 255.255.255.255
Answer is __________________________
40. The default mask for class C is
(a) 255.0.0.0 (b) 255.255.0.0
(c) 255.255.255.0 (d) 255.255.255.255
Answer is __________________________
Answer Key of Chapter No. 5: Network Communication and Protocols
1 | ( b ) | 2 | ( b ) | 3 | ( d ) | 4 | ( a ) | 5 | ( d ) |
6 | ( b ) | 7 | ( d ) | 8 | ( c ) | 9 | ( a ) | 10 | ( b ) |
11 | ( d ) | 12 | ( a ) | 13 | ( d ) | 14 | ( a ) | 15 | ( c ) |
16 | ( b ) | 17 | ( c ) | 18 | ( b ) | 19 | ( a ) | 20 | ( c ) |
21 | ( a ) | 22 | ( a ) | 23 | ( c ) | 24 | ( a ) | 25 | ( a ) |
26 | ( d ) | 27 | ( a ) | 28 | ( b ) | 29 | ( b ) | 30 | ( b ) |
31 | ( a ) | 32 | ( b ) | 33 | ( a ) | 34 | ( b ) | 35 | ( c ) |
36 | ( a ) | 37 | ( a ) | 38 | ( a ) | 39 | ( b ) | 40 | ( c ) |
*********************************
Chapter No. 6: Wireless Communication
MCQs Practice Quiz
1. Which of the following has a range of 40 to 50 km?
(a) Wi-Fi (b) Wi-Max
(c) Bluetooth (d) Infrared
Answer is __________________________
2. Which of these uses extremely high-frequency waves for short-range communication.
(a) Wi-Fi (b) Wi-Max
(c) Bluetooth (d) Infra-red
Answer is __________________________
3. Which of these is used for communication between mobile phones, laptop computers, and digital cameras?
(a) Wi-Fi (b) Wi-Max
(c) Blue tooth (d) Radio signal
Answer is __________________________
4. Which of these is positioned from 160 to 2,000 km above the earth's surface?
(a) Geostationary Earth orbit (b) Medium Earth orbit
(c) Low Earth orbit (d) GALILEO
Answer is __________________________
5. Which orbit is located directly above the earth's Equator?
(a) Geostationary Earth orbit (b) Medium Earth orbit
(c) Low Earth orbit (d) GALILEO
Answer is __________________________
6. What is a fixed station in a cellular wireless network that provides local coverage for mobile communication?
(a) Base station (b) Satellite
(c) Mobile Terminal (d) Global positioning
Answer is __________________________
7. What is used to create web pages?
(a) HTML (b) HTTP
(c) WAP (d) TCP
Answer is __________________________
8. What is HTTP?
(a) Markup language (b) Protocol for mobile phones
(c) Application layer protocol (d) Transport layer protocol
Answer is __________________________
9. Which of these provides a wireless alternative to cable TV and DSL
(a) Bluetooth (b) Infra-red
(c) Wi-Max (d) Wireless Access point
Answer is __________________________
10. In which Earth orbit satellite is placed for navigation.
(a) Geostationary earth orbit (b) Medium earth orbit
(c) Low earth orbit (d) High earth orbit
Answer is __________________________
11. Which device allows wireless devices to connect to a wired network using Wi-Fi
(a) Access point (b) Antenna
(c) Repeater (d) NIC
Answer is __________________________
12. Which of the following is a short-range wireless technology.
(a) Blue tooth (b) Satellite
(c) Cellular (d) GPS
Answer is __________________________
13. Bluetooth technology is commonly used in:
(a) Mobile phones (b) Scanner
(c) Satellite (d) Server
Answer is __________________________
14. A GEO is at the ____________ orbit and revolves at the same speed as the earth
(a) Equatorial (b) Polar
(c) Inclined (d) None
Answer is __________________________
15. GEO stands for.
(a) Geometric Earth Orbit (b) Geo Earth Orbit
(c) Geostationary Earth Orbit (d) Graphical Earth Orbit
Answer is __________________________
16. GPS satellites are ____________ Satellites.
(a) GEO (b) MEO
(c) LEO (d) REO
Answer is __________________________
17. Cellular phones work by using ____________ to communicate.
(a) Radio waves (b)Infrared
(c) Fiber optic (d) Micro borers
Answer is __________________________
18. Each transmitter in cellular systems is called.
(a) Base station (b) Radio station
(c) Main station (d) Mobile station
Answer is __________________________
19. The base station covers a certain area called.
(a) Mobile (b) Cell
(c) System (d) Sector
Answer is __________________________
20. Which of the following is a deal for long-distance communication.
(a) Satellite communication (b) Infrared
(c) Bluetooth (d) Wi-Max
Answer is __________________________
Answer Key of Chapter No. 6: Wireless Communication
1 | ( b ) | 2 | ( d ) | 3 | ( c ) | 4 | ( c ) | 5 | ( a ) |
6 | ( a ) | 7 | ( a ) | 8 | ( c ) | 9 | ( c ) | 10 | ( b ) |
11 | ( a ) | 12 | ( a ) | 13 | ( a ) | 14 | ( a ) | 15 | ( c ) |
16 | ( b ) | 17 | ( a ) | 18 | ( a ) | 19 | ( b ) | 20 | ( a ) |
*********************************
Chapter No. 7: Database Fundamental
MCQs Practice Quiz Worksheet
1. Duplication of data in different files is called ____________
(a) Data inconsistency (b) Redundancy
(c) Data overflow (d) Invalid data
Answer is __________________________
2. If data is not updated in a file in a file-based data management system what types of problems will it cause?
(a) Data inconsistency (b) Redundancy
(c) Data overflow (d) Invalid data
Answer is __________________________
3. A record is also called ___________
(a) Attribute (b) Entity
(c) Field (d) Relation
Answer is __________________________
4. An attribute is also called:
(a) Record (b) Entity
(c) Property (d) Tuple
Answer is __________________________
5. What is a thing of interest to an organization called about which data is to be held?
(a) Field (b) Relation
(c) Entity (d) Attribute
Answer is __________________________
6. In which type of database data is held in tables and tables are linked by a common field.
(a) Hierarchical (b) Network
(c) Relational (d) Object Orient
Answer is __________________________
7. In which database model data is organized in a tree-like structure.
(a) Hierarchical (b) Network
(c) Relational (d) Object Orient
Answer is __________________________
8. What refers to the maximum number of items an instance in one entity can be associated with instances in the related entity.
(a) Relation (b) Cardinality
(c) Modality (d) E.R. Diagram
Answer is __________________________
9. What refers to the minimum number of items an instance in one entity can be associated with instances in
the related entity.
(a) Relation (b) Cardinality
(c) Modality (d) E.R. Diagram
Answer is __________________________
10. What is a key field called that is used in the relationship between tables whose value matches a primary key in
the other table?
(a) Candidate key (b) Secondary key
(c) Alternate key (d) Foreign key
Answer is __________________________
11. Each item of information within a record is called ____________.
(a) Bit (b) Byte
(c) Field (d) Key
Answer is __________________________
12. Each separate piece of information stored in a database is known as ____________.
(a) Table (b) Record
(c) Field (d) Form
Answer is __________________________
13. Which key shows the uniqueness of a table?
(a) Primary key (b) Candidate key
(c) Foreign key (d) Both a and b
Answer is __________________________
14. The collection of programs that enables users to create and maintain a database is called ______________.
(a) File (b) Database
(c) DBMS (d) All
Answer is __________________________
15. The columns of a table correspond to____________.
(a) Field (b) Record
(c) Entity (d) Relationship
Answer is __________________________
16. Which of the following is handled by DBMS.
(a) Data consistency (b) Data security
(c) Data independence (d) All
Answer is __________________________
17. Which of the following is not an advantage of DBMS.
(a) Redundant data (b) Data independence
(c) Backup and recovery (d) Better data quality
Answer is __________________________
18. What is a table in a relational database called?
(a) Relation (b) Tuple
(c) Field (d) Attribute
Answer is __________________________
19. In RDBMS, a table must have:
(a) Primary key (b) Secondary key
(c) Composite key (d) Sort key
Answer is __________________________
20. Which of the following is used to describe the characteristics of any entity.
(a) Relationship (b) Attribute
(c) Cardinality (d) Modality
Answer is __________________________
21. In an ER diagram, an entity is represented by
(a) Ellipse (b) Rectangle
(c) Diamond (d) Circle
Answer is __________________________
22. In the ER diagram, an attribute is represented by:
(a) Ellipse (b) Rectangle
(c) Diamond (d) Circle
Answer is __________________________
23. In ER diagram a relationship is represented by:
(a) Ellipse (b) Rectangle
(c) Diamond (d) Circle
Answer is __________________________
24. The binary relationship can be;
(a) One-to-one (b) One-to-many
(c) Many-to-many (d) All
Answer is __________________________
25. Which of the following is an example of one-to-one?
(a) Student-Reg No (b) Person-automobile
(c) Mother-daughter (d) Person-phone number
Answer is __________________________
26. Which of the following is the one-to-many relationship?
(a) Student-Reg No (b) Person-automobile
(c) Mother-daughter (d) both b and c
Answer is __________________________
27. A relationship between countries and capitals is an example of ____________ relationship.
(a) One-to-one (b) One-to-many
(c) Many-to-many (d) Many-to-one
Answer is __________________________
28. Which form of dependency is removed in 3NF?
(a) Functional (b) Non-functional
(c) Associative (d) Transitive
Answer is __________________________
29. Which form of anomaly is removed in 1NF?
(a) Atomicity (b) Repetition
(c) Partial Functional Dependency (d) Transitive Functional Dependency
Answer is __________________________
30. Which form of anomaly is removed in 2NF?
(a) Atomicity (b) Repetition
(c) Partial Functional Dependency (d) Transitive Functional Dependency
Answer is __________________________
31. Which form of anomaly is removed in 3NF?
(a) Atomicity (b) Repetition
(c) Partial Functional Dependency (d) Transitive Functional Dependency
Answer is __________________________
32. In 3NF non-key attribute must not depend on a ____________
(a) Non-key attribute (b) key Attribute
(c) Composite attribute (d) Sort key
Answer is __________________________
33. The goal of normalization is to;
(a) Get a stable data structure (b) Increase the number of relation
(c) Increase redundancy (d) Point out constraint
Answer is __________________________
34. A functional dependency between two or more non-key attributes is called.
(a) Partial functional dependency (b) Partial non-key dependency
(c) Transitive functional dependency (d) None
Answer is __________________________
35. In ERD, entities are connected to form relationships using ____________.
(a) Rectangle (b) Diamond
(c) Ellipse (d) Line
Answer is __________________________
Answer Key of Chapter No. 7: Database Fundamental
1 | ( b ) | 2 | ( a ) | 3 | ( d ) | 4 | ( d ) | 5 | ( c ) |
6 | ( c ) | 7 | ( a ) | 8 | ( b ) | 9 | ( c ) | 10 | ( d ) |
11 | ( c ) | 12 | ( b ) | 13 | ( d ) | 14 | ( c ) | 15 | ( a ) |
16 | ( d ) | 17 | ( a ) | 18 | ( a ) | 19 | ( a ) | 20 | ( b ) |
21 | ( b ) | 22 | ( a ) | 23 | ( c ) | 24 | ( d ) | 25 | ( a ) |
26 | ( d ) | 27 | ( a ) | 28 | ( d ) | 29 | ( b ) | 30 | ( c ) |
31 | ( d ) | 32 | ( a ) | 33 | ( a ) | 34 | ( c ) | 35 | ( d ) |
*********************************
Chapter No. 8: Database Development
MCQs Practice Quiz Worksheet
1. Which of the following is used to gather information based on one or more criteria?
(a) Table (b) Form
(c) Query (d) Report
Answer is __________________________
2. Which data field type is used to provide descriptive comments?
(a) Text (b) Memo
(c) Auto number (d) Yes/No
Answer is __________________________
3. Selecting records in a table that match a given criteria is known as ____________.
(a) Sorting data (b) Searching data
(c) Updating data (d) Filtering data
Answer is __________________________
4. The maximum number of records in a table that can use the auto number field is slightly more than
(a) 1 million (b) 1 billion
(c) 2 billion (d) 3 billion
Answer is __________________________
5. The database object stores all the information of a database is _____.
(a)Table (b) Form
(c) Query (d) Report
Answer is __________________________
6. What is the default value of a number of characters for a text data type in access?
(a) 30 (b) 40
(c) 50 (d) 60
Answer is __________________________
7. Which query is used to add records from a table to another table?
(a) Select query (b) Update query
(c) Append query (d) Make table query
Answer is __________________________
8. Which query is used to change data in existing records?
(a) Select query (b) Update query
(c) Append query (d) Make table query?
Answer is __________________________
9. In which tab of the Access ribbon Relationship icons is located
(a) Home (b) Create
(c) External data (d) Database tool
Answer is __________________________
10. In which tab of access ribbon query Design icon is located
(a) Home (b) Create
(c) External data (d) Database tool
Answer is __________________________
11. Which of the following is NOT a database object?
(a) Queries (b) Forms
(c) Relationships (d) Report
Answer is __________________________
12. Which of the following database objects is created first before any other is created?
(a) Table (b) Form
(c) Query (d) Report
Answer is __________________________
13. Which of the following objects is used to extract information from the database?
(a) Table (b) Form
(c) Query (d) Report
Answer is __________________________
14. Which object is the output of the database application?
(a) Table (b) Form
(c) Query (d) Report
Answer is __________________________
15. Tables in a relational database are related by sharing ____________.
(a) Field (b) Report
(c) Record (d) Query
Answer is __________________________
16. Forms are designed to____________.
(a) Input data (b) Manipulate data
(c) Accept change (d) All
Answer is __________________________
17. In MS Access, which form layout is used to display a single record at a time?
(a)Tabular (b) Columnar
(c) Datasheet (d) None
Answer is __________________________
18. A report may be based on:
(a) A table but not a query (b) A query but not a table
(c) Both a table and a query (d) none of these
Answer is __________________________
19. The extension of the MS ACCESS database is____________
(a) .mdb (b) .msd
(c) .acc (d) .madb
Answer is __________________________
20. A database consists of various components called ____________.
(a) Tools (b) Properties
(c) Objects (d) Entities
Answer is __________________________
Answer Key of Chapter No. 8: Database Development
1. | ( c ) | 2. | ( b ) | 3. | ( d ) | 4. | ( c ) | 5. | ( a ) |
6. | ( c ) | 7. | ( c ) | 8. | ( b ) | 9. | ( d ) | 10. | ( b ) |
11. | ( c ) | 12. | ( a ) | 13. | ( c ) | 14. | ( d ) | 15. | ( a ) |
16. | ( d ) | 17. | ( b ) | 18. | ( c ) | 19. | ( a ) | 20. | ( c ) |
0 Comments
If you have any QUESTIONs or DOUBTS, Please! let me know in the comments box or by WhatsApp 03339719149